Entity DefinitionLogical Name : CustomerOccasion |
|---|
| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
|---|---|---|---|---|---|
| CustomerOccasionTypeCode (FK)(PK) | A retailer assigned code for the CustomerOccasionType. | TY_OCCN_CT | Code6 | char(6) | CustomerOccasionType(PA_OCCN_CT_TYP) |
| CustomerID (FK)(PK) | A unique system assigned identifier for the Customer. | ID_CT | Identity | integer | Customer(PA_CT) |
| CustomerOccasionDate (PK) | The start date of a an event or other occasion that a customer celebrates. | DC_OCCN_CT | DateCalendar | date |
| Parent Entity | Verb Phrase | Child Entity |
|---|---|---|
| CustomerOccasionType | describes | CustomerOccasion |
| Customer | celebrates | CustomerOccasion |
| CustomerOccasion | leads to | CustomerGiftRegistry |
| Logical View |
|---|
| Logical 02300 - Retail Transaction - Macro View |
| Logical 07010 - Customer Account Information Extended |
| Logical 07040 - Customer Segment Dependent Behavior |